<?php
/**
 * author:歪妻
 * Date: 2020/11/2 0002
 */

// 计算出数据库的路径，以便SQLite / PDO可以连接
$root = __DIR__;
$database = $root . '/../data/data.sqlite';
$dsn = 'sqlite:' . $database;
// 计算出数据库的路径，以便SQLite / PDO可以连接
$pdo = new PDO($dsn);
$stmt = $pdo->query(
    'SELECT
        id ,title, created_at, body
    FROM
        post
    ORDER BY
        created_at DESC'
);
if ($stmt === false)
{
    throw new Exception('运行此查询时出现问题');
}
?>

<!DOCTYPE html>
<html>
<head>
    <title>A blog application</title>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
</head>
<body>
    <?php require 'templates/title.php' ?>
<?php while ($row = $stmt->fetch(PDO::FETCH_ASSOC)): ?>
    <h2>
        <?php echo htmlspecialchars($row['title'], ENT_HTML5, 'UTF-8') ?>
    </h2>
    <div>
        <?php echo $row['created_at'] ?>
    </div>
    <p>
        <?php echo htmlspecialchars($row['body'], ENT_HTML5, 'UTF-8') ?>
    </p>
    <p>
        <a href="view-post.php?post_id=<?php echo $row['id']?>">Read more...</a>

    </p>
<?php endwhile ?>
</body>
</html>
